How to Add a Default Value to a Column

SQL Tutorial Home

In order to add a default value in Oracle, you need to use the alter table with the set default clause:

alter table employee modify (last_bonus default current_date);

IN THIS PAGE